package cn.kgc.mapper;

import cn.kgc.pojo.DmSchedulerSeat;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface DmSchedulerSeatMapper {

    //根据id获取表数据
    public DmSchedulerSeat getDmSchedulerSeatById(@Param(value = "id") Long id) throws Exception;

    //多条件查询获取表中的数据,返回满足条件的一条或多条数据
    public List<DmSchedulerSeat> getDmSchedulerSeatListByMap(Map
                                                                     <String, Object> param) throws Exception;

    //多条件获取满足条件的总记录数据
    public Integer getDmSchedulerSeatCountByMap(Map
                                                        <String, Object> param) throws Exception;

    //插入数据表
    public Integer insertDmSchedulerSeat(DmSchedulerSeat dmSchedulerSeat) throws Exception;

    //修改数据表
    public Integer updateDmSchedulerSeat(DmSchedulerSeat dmSchedulerSeat) throws Exception;

    //删除数据表
    public Integer deleteDmSchedulerSeatById(@Param(value = "id") Long id) throws Exception;

    //重置座位
    Integer flushUpdateDmSchedulerSeat();
}